package com.xiaotu.dao.mysql8;


import com.xiaotu.entity.SyncHotSwIndexModel;
import com.xiaotu.entity.SyncSwIndexModel;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zhangxiao
 * @create 2021-11-01 14:24
 */
public interface Mysql8SwIndexMapper {

    @Select(" SELECT starid FROM hot1infob15xiaotuindex090901 ORDER BY xiaotuindex DESC ")
    List<SyncHotSwIndexModel> getHotSwIndex();

    @Select(" SELECT " +
            " t1.starid, " +
            " t1.starname, " +
            " t1.wltvzp_xiaotuindex tv_nettv_xtindex, " +
            " t2.film_xiaotuindex movie_nettv_xtindex, " +
            " t3.wlddyzp_xiaotuindex netmovie_xtindex  " +
            "FROM " +
            " `3infob26writer_wltvzp_rank091201` t1 " +
            " LEFT JOIN `3infob26writer_film_rank091201` t2 ON t1.starid = t2.starid " +
            "LEFT JOIN `3infob26writer_wlddyzp_rank091201` t3 ON t1.starid = t3.starid; ")
    List<SyncSwIndexModel> getSwIndex();
}
